<?php
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 2010
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `ecs_goods_activity`;");
E_C("CREATE TABLE `ecs_goods_activity` (
  `act_id` mediumint(8) unsigned NOT NULL auto_increment,
  `act_name` varchar(255) NOT NULL,
  `act_desc` text NOT NULL,
  `act_type` tinyint(3) unsigned NOT NULL,
  `goods_id` mediumint(8) unsigned NOT NULL,
  `product_id` mediumint(8) unsigned NOT NULL default '0',
  `goods_name` varchar(255) NOT NULL,
  `start_time` int(10) unsigned NOT NULL,
  `end_time` int(10) unsigned NOT NULL,
  `is_finished` tinyint(3) unsigned NOT NULL,
  `ext_info` text NOT NULL,
  PRIMARY KEY  (`act_id`),
  KEY `act_name` (`act_name`,`act_type`,`goods_id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8");
E_D("replace into `ecs_goods_activity` values('1','戴尔（Dell）V260R-376台式电脑（双核i3-2120 2G内存 500G硬盘 1G独立显卡DVD 键鼠 三年上门服务)','活动说明','1','5','0','戴尔（Dell）V260R-376台式电脑（双核i3-2120 2G内存 500G硬盘 1G独立显卡DVD 键鼠 三年上门服务)','1331568000','1394985600','0','a:4:{s:12:\"price_ladder\";a:2:{i:0;a:2:{s:6:\"amount\";i:20;s:5:\"price\";d:2999;}i:1;a:2:{s:6:\"amount\";i:50;s:5:\"price\";d:2500;}}s:15:\"restrict_amount\";i:100;s:13:\"gift_integral\";i:100;s:7:\"deposit\";d:1000;}');");
E_D("replace into `ecs_goods_activity` values('2','富士通（FUJITSU）LH531 14.1英寸笔记本电脑（i3-2350M 2G 320G 第二代核芯显卡 D刻 蓝牙HDMI win7）型动黑','头文字DAA已到店！北京首家！仅20元，即享原价100元的中关村科乐美电玩城游戏币50枚，超便利地理位置、超豪华游戏阵容，每人可购多张、给力电玩美好时光！','1','7','0','富士通（FUJITSU）LH531 14.1英寸笔记本电脑（i3-2350M 2G 320G 第二代核芯显卡 D刻 蓝牙HDMI win7）型动黑','1331568000','1394985600','0','a:4:{s:12:\"price_ladder\";a:2:{i:0;a:2:{s:6:\"amount\";i:30;s:5:\"price\";d:2999;}i:1;a:2:{s:6:\"amount\";i:50;s:5:\"price\";d:2500;}}s:15:\"restrict_amount\";i:100;s:13:\"gift_integral\";i:1000;s:7:\"deposit\";d:2000;}');");
E_D("replace into `ecs_goods_activity` values('3','活动名称','活动描述','0','5','0','戴尔V260R-376台式电脑（双核i3-2120 2G内存 500G硬盘 1G独立显卡DVD 键鼠 三年上门服务)','1331801820','1395565020','0','a:4:{s:11:\"start_price\";s:4:\"1.00\";s:9:\"end_price\";s:6:\"800.00\";s:9:\"max_price\";s:4:\"5000\";s:11:\"cost_points\";s:1:\"1\";}');");
E_D("replace into `ecs_goods_activity` values('4','直降150元！西门子5.6公斤超薄','活动说明','1','15','0','直降150元！西门子5.6公斤超薄','1331827200','1395331200','0','a:4:{s:12:\"price_ladder\";a:2:{i:0;a:2:{s:6:\"amount\";i:10;s:5:\"price\";d:2700;}i:1;a:2:{s:6:\"amount\";i:20;s:5:\"price\";d:2000;}}s:15:\"restrict_amount\";i:0;s:13:\"gift_integral\";i:1000;s:7:\"deposit\";d:1000;}');");
E_D("replace into `ecs_goods_activity` values('5','只要169元！！3月特献~~','活动说明','1','20','0','只要169元！！3月特献~~','1331913600','1395331200','0','a:4:{s:12:\"price_ladder\";a:2:{i:0;a:2:{s:6:\"amount\";i:30;s:5:\"price\";d:200;}i:1;a:2:{s:6:\"amount\";i:50;s:5:\"price\";d:160;}}s:15:\"restrict_amount\";i:0;s:13:\"gift_integral\";i:100;s:7:\"deposit\";d:100;}');");
E_D("replace into `ecs_goods_activity` values('6','周生生 黄金(足金)天使系列','活动说明','1','24','0','周生生 黄金(足金)天使系列','1334332800','1397577600','0','a:4:{s:12:\"price_ladder\";a:2:{i:0;a:2:{s:6:\"amount\";i:10;s:5:\"price\";d:500;}i:1;a:2:{s:6:\"amount\";i:30;s:5:\"price\";d:380;}}s:15:\"restrict_amount\";i:0;s:13:\"gift_integral\";i:200;s:7:\"deposit\";d:200;}');");
E_D("replace into `ecs_goods_activity` values('7','兰蔻水份缘舒缓精华液 30ml','仅19.9元，尊享原价599元的浩沙健身周卡套餐（仅可在开卡店','1','18','0','兰蔻水份缘舒缓精华液 30ml','1331913600','1395331200','0','a:4:{s:12:\"price_ladder\";a:2:{i:0;a:2:{s:6:\"amount\";i:10;s:5:\"price\";d:80;}i:1;a:2:{s:6:\"amount\";i:50;s:5:\"price\";d:60;}}s:15:\"restrict_amount\";i:0;s:13:\"gift_integral\";i:50;s:7:\"deposit\";d:100;}');");

require("../../inc/footer.php");
?>